﻿CREATE TABLE [cex].[ContentNode]
(
[Id] [int] NOT NULL IDENTITY(1, 1),
[SiteId] [int] NOT NULL,
[NodeGuid] [uniqueidentifier] NOT NULL,
[Name] [varchar] (100) NULL,
[DisplayName] [varchar] (100) NULL,
[TemplateId] [int] NOT NULL,
[Summary] [varchar] (2000) NULL,
[Notes] [nvarchar] (2000) NULL,
[CreatedDateTime] [datetime] NOT NULL,
[PublishFrom] [datetime] NULL,
[PublishTo] [datetime] NULL,
[RequiresPublishing] [bit] NOT NULL,
[ReadyToPublish] [bit] NOT NULL,
[DeveloperLocked] [bit] NOT NULL,
[Deleted] [bit] NOT NULL,
[CID] [timestamp] NOT NULL
) ON [PRIMARY]


